﻿
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[usp_PriceFactor_Tbl_Ins] 
@ConstructionID int, 
@GenericYarnID int, 
@TierPriceIndicator nvarchar(50), 
@PriceMultiplier float,
@TierID int

AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
Insert into Pricefactor_Tbl (ConstructionID, GenericYarnID, TierPriceIndicator, PriceMultiplier, TierID) values (@ConstructionID, @GenericYarnID, @TierPriceIndicator, @PriceMultiplier, @TierID)
END